42. 练习：AND 和 BETWEEN

使用 AND 和 BETWEEN 运算符的问题

  1. 编写一个查询，返回所有 orders (订单)，其中 standard_qty （标准纸数量）超过 1000， poster_qty （海报纸数量） 是 0， gloss_qty （铜板高光纸数量）也是 0。

  2. 使用 accounts 表查找所有不以 'C' 开始但以 's' 结尾的公司名。

  3. 使用 web_events 表查找通过 organic 或 adwords 渠道来联系的，并在 2016 年的任何时间开通帐户的个人全部信息，并按照从最新到最旧的顺序排列。

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity , so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: sql-evaluator
  • Opened files (when workspace is loaded): n/a

Next Concept